Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NLS_CHARSET_DECL_LEN

Syntax

Description of the illustration nls_charset_decl_len.gif

Purpose

`NLS_CHARSET_DECL_LEN` returns the declaration length (in number of characters) of an `NCHAR` column. The `byte_count` argument is the width of the column. The `char_set_id` argument is the character set ID of the column.

Examples

The following example returns the number of characters that are in a 200-byte column when you are using a multibyte character set:

    SELECT NLS_CHARSET_DECL_LEN
      (200, nls_charset_id('ja16eucfixed'))
       FROM DUAL;

    NLS_CHARSET_DECL_LEN(200,NLS_CHARSET_ID('JA16EUCFIXED'))
    --------------------------------------------------------
                                                         100